Occurs before data is changed in the column.
Private Sub object.WillChangeData(NewValue as Variant, Cancel as Boolean)
The WillChangeData event syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| NewValue | A Variant expression containing the data to be applied to the column. |
| Cancel | A Boolean expression indicating if RDO should prohibit the change. |
The settings for Cancel are:
| Setting | Description |
| True | RDO will prohibit the change. |
| False | (Default) RDO will not prohibit the change. |
Remarks
This event is raised just before RDO commits any change to the data in a column. By trapping this event, you can either modify the new value, or prohibit the change by modifying the Cancel argument.
If you modify the NewValue parameter, the modified value is assigned to the column’s Value property. This allows you translate or substitute data.
By default, the Cancel argument is False, but if you set it to True, the change to the column’s data is canceled, and RDO generates a trappable error.